package com.alibaba.ai.dao;

import com.alibaba.ai.entity.Search;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface SearchMapper {
    //小区房价搜索功能
    @Select("select *from (select *from C_SEARCH left join C_STATE on C_SEARCH.id=C_STATE.C_STATE_ID) as C_SEARCH left join " +
            "C_PARTICULARS on C_SEARCH.id=C_PARTICULARS.C_STATE_ID where C_DISTRICT like '%${C_DISTRICT}%'\" +\n" +
            "// \" and C_TRADINGAREA like '%${C_TRADINGAREA}%' and C_VILLAGENAME like '%${C_TRADINGAREA}%'\"")
    List<Search> selectBysearch(String cDistrict, String cTradingArea, String cVillageName);
}
